Using ARCHIBUS with Sybase 10 or 11

ARCHIBUS ships its sample database (hq.db) and its schema database (schema.db) in Sybase SQL Anywhere 9 format, as many existing sites use that version and Sybase databases are not downward-convertable.  

If you have Sybase SQL Anywhere 10 or 11, you must upgrade your ARCHIBUS databases to the new Sybase SQL Anywhere 10 or 11 format before starting the databases on the Sybase 10 or 11 database server.  The steps to do so are outlined below.

To update an older Sybase database, first open Sybase Central. Then, follow the steps illustrated below using Sybase 10.

  1. Change the time-format that ARCHIBUS uses in queries to adjust to a change in Sybase. To do so:
    1. Open the WEB-INF\config\context\compatibility\afm-config.xml in a text editor
    2. Find the <engine type="Sybase"> tag.
    3. Change the sql\format\time attribute from
      time="yyyy-MM-dd HH:mm:ss.S"
      to
      time="HH:mm:ss.S"

  2. Choose the "Prepare a Version 9 or Earlier Database for SQL Anywhere 10" option.

 

 

  1. Read the Welcome message.


     
  2. Choose to unload a non-running database:



     
  3. Specify these three options:


     
  4. Choose to unload and reload into a new database:


     
  5. Set the path and name of the new database:


     
  6. Select what to unload:


     
  7. Connect to the database:


     
  8. The routine will display the following:


     
  9. The routine will display the following:


     
  10. When you are finished and have connected to the HQ database, your view in Sybase Central will appear as follows: